Implementing spatial datawarehouse hierarchies in object-relational DBMSs
نویسندگان
چکیده
Spatial Data Warehouses (SDWs) allow to analyze historical data represented in a space supporting the decision-making process. SDW applications require a multidimensional view of data that includes dimensions with hierarchies and facts with associated measures. In particular, hierarchies are important since traversing them users can analyze detailed and aggregated measures. To better represent users’ requirements for SDWs, the conceptual model with spatial support should be used. Afterwards, the conceptual schema is translated to the logical and physical schemas. However, during the translation process the semantics can be lost. In this paper, we present the translation of spatial hierarchies from the conceptual to physical schemas represented in the MultiDimER model and Oracle 10g Spatial, respectively. Further, to ensure the semantic equivalence between the conceptual and the physical schemas, integrity constraints are exemplified mainly using triggers.
منابع مشابه
Logical Representation of a Conceptual Model for Spatial Data Warehouses
The MultiDimER model is a conceptual model used for representing a multidimensional view of data for Data Warehouse (DW) and On-Line Analytical Processing (OLAP) applications. This model includes a spatial extension allowing spatiality in levels, hierarchies, fact relationships, and measures. In this way decisionmaking users can represent in an abstract manner their analysis needs without consi...
متن کاملAN OVERVIEW OF THE OBJECT PROTOCOL MODEL (OPM) AND THE OPM DATA MANAGEMENT TOOLSy
| In this paper, we overview the Object-Protocol Model (OPM) and a suite of data management tools based on OPM. OPM is a data model that allows specifying database structures and queries in terms of objects and protocols speciic to scientiic (e.g., molecular biology laboratory) applications. Thus, scientiic experiments and their resources can be described using OPM in a uniied way. OPM data man...
متن کاملObject-Relational DBMS
In this paper we present a classification of the applications that require DBMS technology and show where Relational DBMSs, Object-oriented DBMSs and ObjectRelational DBMSs fit. Our purpose is to indicate the kinds of problems each kind of DBMS solves. As will be seen, "one size does not fit all"; i.e. there is no DBMS that solves all the applications we are going to discuss. Then, we indicate ...
متن کاملExploiting the Functionality of Object-Oriented Database Management Systems for Information Retrieval
In this paper, we present the approach of FIRE to utilizing an object-oriented Database Management System (DBMS) for Information Retrieval (IR) purposes. First, a comprehensive overview of previous attempts to use DBMSs for implementing IR systems is given. Next, di erences between DBMSs and IR systems, with regard to indexing and retrieval, are discussed. In addition, some shortcomings of DBMS...
متن کاملThe exploration of a category theory-based virtual geometrical product specification system for design and manufacturing
ions such as inheritance are more naturally represented by graphs than as sets (Levene and Poulovassilis, 1991 [33]; Poulovassilis and Levene, 1994 [34]). (4) Data modellings in object-relational DBMSs still have weaknesses in semantic supports. For example, because the functional data model is the “lowest common denominator” of data models (refer to Section 2.2.3.1), there is lack of semantic ...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2007